/*
MySQL Backup
Database: happy_shopping
Backup Time: 2020-04-02 23:28:25
*/

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `happy_shopping`.`dictionary`;
DROP TABLE IF EXISTS `happy_shopping`.`dictionary_item`;
DROP TABLE IF EXISTS `happy_shopping`.`files`;
DROP TABLE IF EXISTS `happy_shopping`.`menu`;
DROP TABLE IF EXISTS `happy_shopping`.`order`;
DROP TABLE IF EXISTS `happy_shopping`.`order_item`;
DROP TABLE IF EXISTS `happy_shopping`.`product`;
DROP TABLE IF EXISTS `happy_shopping`.`product_inventory`;
DROP TABLE IF EXISTS `happy_shopping`.`product_sku`;
DROP TABLE IF EXISTS `happy_shopping`.`report_loss`;
DROP TABLE IF EXISTS `happy_shopping`.`shop`;
DROP TABLE IF EXISTS `happy_shopping`.`user`;
DROP TABLE IF EXISTS `happy_shopping`.`user_address`;
DROP TABLE IF EXISTS `happy_shopping`.`user_shopping_cart`;
CREATE TABLE `dictionary` (
  `id` bigint(20) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `code` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
  `sequence` int(10) DEFAULT NULL,
  `create_user_id` bigint(20) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `last_update_user_id` bigint(20) DEFAULT NULL,
  `last_update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='字典表';
CREATE TABLE `dictionary_item` (
  `id` bigint(20) NOT NULL,
  `name` int(10) DEFAULT NULL,
  `value` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `parent_id` bigint(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='字典表项';
CREATE TABLE `files` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `file_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `now_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `save_path` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `file_type` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `file_size` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `upload_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=98067334098321415 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT;
CREATE TABLE `menu` (
  `id` bigint(20) NOT NULL,
  `privilege_type` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
  `privilege_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `parent_id` bigint(50) DEFAULT NULL,
  `sequence` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `create_user_id` bigint(20) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `last_update_user_id` bigint(20) DEFAULT NULL,
  `last_update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='二级菜单检索表';
CREATE TABLE `order` (
  `id` bigint(20) NOT NULL,
  `state` int(255) DEFAULT NULL,
  `amount` float(255,2) NOT NULL DEFAULT '0.00',
  `user_id` bigint(20) NOT NULL,
  `user_address_id` bigint(20) NOT NULL,
  `user_shopping_cart_id` bigint(20) DEFAULT NULL,
  `create_user_id` bigint(20) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `last_update_user_id` bigint(20) DEFAULT NULL,
  `last_update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='订单表';
CREATE TABLE `order_item` (
  `id` bigint(20) NOT NULL,
  `order_id` bigint(20) NOT NULL,
  `product_id` bigint(20) NOT NULL,
  `product_sku_id` bigint(20) NOT NULL,
  `product_count` int(255) NOT NULL,
  `create_user_id` bigint(20) DEFAULT NULL,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `last_update_user_id` bigint(20) DEFAULT NULL,
  `last_update_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='订单项';
CREATE TABLE `product` (
  `id` bigint(20) NOT NULL,
  `shop_id` bigint(20) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `product_type` int(1) DEFAULT '0',
  `state` int(1) DEFAULT '0',
  `imgURl` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `create_user_id` bigint(20) DEFAULT NULL,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `last_update_user_id` bigint(20) DEFAULT NULL,
  `last_update_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='商品信息表';
CREATE TABLE `product_inventory` (
  `id` bigint(20) NOT NULL,
  `shop_id` bigint(20) NOT NULL,
  `product_id` bigint(20) NOT NULL,
  `count` int(10) DEFAULT NULL,
  `create_user_id` bigint(20) DEFAULT NULL,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `last_update_user_id` bigint(20) DEFAULT NULL,
  `last_update_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='商品库存表\r\n';
CREATE TABLE `product_sku` (
  `id` bigint(20) NOT NULL,
  `shop_id` bigint(20) NOT NULL,
  `product_id` int(11) DEFAULT NULL,
  `sku_name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `sku_spec` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `sku_count` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `sku_price` decimal(10,2) NOT NULL,
  `state` int(1) DEFAULT '0',
  `create_user_id` bigint(20) DEFAULT NULL,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `last_update_user_id` bigint(20) DEFAULT NULL,
  `last_update_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='用户规格表';
CREATE TABLE `report_loss` (
  `id` bigint(20) NOT NULL,
  `type` int(2) DEFAULT NULL COMMENT '类型',
  `result` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '描述',
  `money` decimal(10,2) DEFAULT NULL COMMENT '金额',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT;
CREATE TABLE `shop` (
  `id` bigint(20) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '店铺名称',
  `keeper_id` bigint(255) NOT NULL COMMENT '店主Id',
  `address` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '店铺地址',
  `longitude` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '经度',
  `latitude` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '纬度',
  `state` int(1) DEFAULT '0' COMMENT '状态',
  `create_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人Id',
  `last_update_time` datetime DEFAULT NULL,
  `last_update_user_id` bigint(20) DEFAULT NULL,
  `keeper_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '店主姓名',
  `mobile` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '店主手机号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='店铺表';
CREATE TABLE `user` (
  `id` bigint(20) NOT NULL COMMENT '主键ID',
  `realname` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '真实姓名',
  `nickname` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '昵称',
  `avatar_url` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `country` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
  `province` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
  `city` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
  `gender` varchar(1) COLLATE utf8mb4_bin DEFAULT NULL,
  `open_id` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  `language` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
  `mobile` varchar(11) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '手机号-账户',
  `password` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '密码',
  `type` int(1) NOT NULL COMMENT '用户类型：‘0’运营人员，‘1’店主，‘2’普通用户',
  `state` int(1) DEFAULT '0' COMMENT '用户状态',
  `create_user_id` bigint(20) DEFAULT NULL,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `last_update_user_id` bigint(20) DEFAULT NULL,
  `last_update_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='用户信息表';
CREATE TABLE `user_address` (
  `id` bigint(255) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户Id',
  `province` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '省',
  `city` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '市',
  `county` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '区',
  `street` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '街道',
  `address` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '详细地址',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人Id',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `last_update_user_id` bigint(20) DEFAULT NULL COMMENT '最近跟新人ID',
  `last_update_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '最近更新时间',
  `is_default` int(2) DEFAULT NULL COMMENT '是否默认收货地址',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='用户收货地址';
CREATE TABLE `user_shopping_cart` (
  `id` bigint(20) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  `product_sku_id` bigint(20) DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  `create_user_id` bigint(20) DEFAULT NULL,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `last_update_user__id` bigint(20) DEFAULT NULL,
  `last_update_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='用户购物车';
BEGIN;
LOCK TABLES `happy_shopping`.`dictionary` WRITE;
DELETE FROM `happy_shopping`.`dictionary`;
INSERT INTO `happy_shopping`.`dictionary` (`id`,`name`,`code`,`sequence`,`create_user_id`,`create_time`,`last_update_user_id`,`last_update_time`) VALUES (126566, '店铺类型', 'shoptype', 1, 1, '2019-02-14 21:23:06', 1, '2019-02-14 21:23:09'),(98067334098321410, '用户类型', 'usertype', 0, NULL, '2019-02-16 18:57:11', NULL, '2019-02-16 18:57:11');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `happy_shopping`.`dictionary_item` WRITE;
DELETE FROM `happy_shopping`.`dictionary_item`;
INSERT INTO `happy_shopping`.`dictionary_item` (`id`,`name`,`value`,`parent_id`) VALUES (4, 1, '收货人', 1265),(5, 55555, '888888', 1265),(6, 8888, '888888', 1265),(98062972508700676, 1, '222', 98062972508700675),(98062972508700677, 999, '3', 98062972508700675),(98062972508700678, 232, '323', 98062972508700675),(98067334098321408, 1, '微店铺', 126566),(98067334098321409, 2, '小店铺', 126566),(98067334098321411, 0, '超级管理员', 98067334098321410),(98067334098321412, 1, '微店主', 98067334098321410),(98067334098321413, 2, '普通用户', 98067334098321410),(98618668396576769, 3, '测试用', 98067334098321410),(98624044219236352, 5, '556', 98067334098321410);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `happy_shopping`.`files` WRITE;
DELETE FROM `happy_shopping`.`files`;
INSERT INTO `happy_shopping`.`files` (`id`,`file_name`,`now_name`,`save_path`,`url`,`file_type`,`file_size`,`upload_time`) VALUES (98040958385389569, 'logo.png', '01f043cd-4438-40c3-a79e-1a20043fd876.png', '/E:/FileHouse/20190129/01f043cd-4438-40c3-a79e-1a20043fd876.png', 'http://192.168.1.109:8081/files/98040958385389569', '.png', '33554', '2019-01-29 05:31:01'),(98040958385389570, 'shop.jpg', '1e1a75cf-ae25-4d6b-9f75-6bc0a243bcfc.jpg', '/E:/FileHouse/20190129/1e1a75cf-ae25-4d6b-9f75-6bc0a243bcfc.jpg', 'http://192.168.1.109:8081/files/98040958385389570', '.jpg', '6538', '2019-01-29 05:36:38'),(98067334098321414, '1.jpg', '3c0ac27f-ba78-43dc-ac09-58d3b2456b39.jpg', '/E:/FileHouse/20190217/3c0ac27f-ba78-43dc-ac09-58d3b2456b39.jpg', 'http://0:0:0:0:0:0:0:1:8090/files/98067334098321414', '.jpg', '229535', '2019-02-17 05:50:28');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `happy_shopping`.`menu` WRITE;
DELETE FROM `happy_shopping`.`menu`;
INSERT INTO `happy_shopping`.`menu` (`id`,`privilege_type`,`privilege_name`,`title`,`url`,`icon`,`parent_id`,`sequence`,`create_user_id`,`create_time`,`last_update_user_id`,`last_update_time`) VALUES (2, 'Menu', '店铺管理', NULL, '#shopList.html', 'fa fa-university', NULL, '1', 1, '2018-12-03 17:06:14', 1, '2018-12-03 17:06:17'),(3, 'Menu', '用户管理', NULL, '#userList.html', 'fa fa-user', NULL, '3', NULL, '2018-12-04 09:58:27', NULL, '2018-12-04 09:58:27'),(4, 'Menu', '商品管理', NULL, '#productList.html', 'fa fa-th', NULL, '2', NULL, '2018-12-04 10:05:11', NULL, '2018-12-04 10:05:11'),(5, 'Menu', '字典管理', NULL, '#dictionaryList.html', 'fa fa-list', NULL, '4', NULL, '2018-12-04 15:14:10', NULL, '2018-12-04 15:14:10'),(97962609206099970, 'Menu', '二级目录', 'yuy', 'yu', 'yuy', 97962609206099969, 'yu', NULL, '2018-12-06 15:25:56', NULL, '2018-12-06 15:25:56'),(99999999999999999, 'Menu', '菜单管理', NULL, '#menuList.html', 'fa fa-bars', NULL, '999', NULL, NULL, NULL, NULL);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `happy_shopping`.`order` WRITE;
DELETE FROM `happy_shopping`.`order`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `happy_shopping`.`order_item` WRITE;
DELETE FROM `happy_shopping`.`order_item`;
INSERT INTO `happy_shopping`.`order_item` (`id`,`order_id`,`product_id`,`product_sku_id`,`product_count`,`create_user_id`,`create_time`,`last_update_user_id`,`last_update_time`) VALUES (97920595282362368, 666, 3333, 666, 5, 1, '2018-11-08 15:12:02', 2, '2018-11-07 12:51:35'),(97920595282362369, 666, 3333, 666, 5, 1, '2018-11-08 15:11:58', 2, '2018-11-07 12:53:17'),(97920595282362370, 656, 3333, 666, 5, 1, '2018-11-07 12:56:09', 2, '2018-11-07 12:56:09'),(97920595282362371, 656, 3333, 666, 5, 1, '2018-11-07 12:56:09', 2, '2018-11-07 12:56:09');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `happy_shopping`.`product` WRITE;
DELETE FROM `happy_shopping`.`product`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `happy_shopping`.`product_inventory` WRITE;
DELETE FROM `happy_shopping`.`product_inventory`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `happy_shopping`.`product_sku` WRITE;
DELETE FROM `happy_shopping`.`product_sku`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `happy_shopping`.`report_loss` WRITE;
DELETE FROM `happy_shopping`.`report_loss`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `happy_shopping`.`shop` WRITE;
DELETE FROM `happy_shopping`.`shop`;
INSERT INTO `happy_shopping`.`shop` (`id`,`name`,`keeper_id`,`address`,`longitude`,`latitude`,`state`,`create_time`,`create_user_id`,`last_update_time`,`last_update_user_id`,`keeper_name`,`mobile`) VALUES (1, '陶鑫焕的小店', 1, '江苏省', '123', '1312', 0, '2019-01-21 15:11:50', 1, '2019-01-21 15:11:50', 88888888, '陶鑫焕', '13476287890'),(97988921383714816, '测试店铺', 1, '江苏省无锡市宜兴市徐舍镇蒋店村', NULL, NULL, 0, '2019-01-21 15:11:52', 88888888, '2019-01-21 15:11:52', 88888888, '陶鑫焕', '13476287890');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `happy_shopping`.`user` WRITE;
DELETE FROM `happy_shopping`.`user`;
INSERT INTO `happy_shopping`.`user` (`id`,`realname`,`nickname`,`avatar_url`,`country`,`province`,`city`,`gender`,`open_id`,`language`,`mobile`,`password`,`type`,`state`,`create_user_id`,`create_time`,`last_update_user_id`,`last_update_time`) VALUES (1, '陶鑫焕', '超级管理员', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '13476287890', '123456', 0, NULL, 88888888, '2019-02-16 21:16:34', 88888888, '2018-11-14 13:30:23'),(88888888, '陶鑫焕', '幻心桃', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '13476287891', '123456', 1, 0, 88888888, '2019-02-16 21:16:27', 1, '2019-02-16 09:51:00'),(98029352645558275, '开发测试用', '哈哈', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '13338759973', '123456', 2, 0, 10086, '2019-02-16 09:51:06', 1, '2019-02-16 09:51:06'),(98618668396576770, '1323232', '霓虹', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '13376287890', '123456', 1, 0, 1, '2020-03-05 10:31:10', 1, '2020-03-05 10:31:10');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `happy_shopping`.`user_address` WRITE;
DELETE FROM `happy_shopping`.`user_address`;
INSERT INTO `happy_shopping`.`user_address` (`id`,`user_id`,`province`,`city`,`county`,`street`,`address`,`create_user_id`,`create_time`,`last_update_user_id`,`last_update_time`,`is_default`) VALUES (41414, 1, '徐舍镇', '无锡市宜兴市', '徐舍镇', '已成街道', '蒋店', NULL, '2019-02-16 10:15:32', NULL, '2018-12-06 11:10:03', 1);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `happy_shopping`.`user_shopping_cart` WRITE;
DELETE FROM `happy_shopping`.`user_shopping_cart`;
UNLOCK TABLES;
COMMIT;
